Tabela LContractContact

Definicja tabeli LContractContact

Name

LContractContact

Code

LContractContact

Comment

PL: Ustalenie danych kontaktowych dla umowy
EN: Assignement contact data for contract


Lista kolumn tabeli LContractContact

Name

Code

ContractID

ContractID

ContactID

ContactID

StartDT

StartDT

StopDT

StopDT

RangeContacts

RangeContacts

Function

Function


Kolumna ContractID tabeli LContractContact

Definicja kolumny ContractID tabeli LContractContact

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContactID tabeli LContractContact

Definicja kolumny ContactID tabeli LContractContact

Name

ContactID

Code

ContactID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LContractContact

Definicja kolumny StartDT tabeli LContractContact

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LContractContact

Definicja kolumny StopDT tabeli LContractContact

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna RangeContacts tabeli LContractContact

Definicja kolumny RangeContacts tabeli LContractContact

Name

RangeContacts

Code

RangeContacts

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Function tabeli LContractContact

Definicja kolumny Function tabeli LContractContact

Name

Function

Code

Function

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Lista kluczy tabeli LContractContact

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractContact

Definicja klucza Identifier_1 tabeli LContractContact

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment